﻿CREATE TABLE [dbo].[Itinerary] (
    [nItinerarySetID] BIGINT          IDENTITY (1, 1) NOT NULL,
    [strName]         NVARCHAR (256)  NOT NULL,
    [nMajor]          BIGINT          NOT NULL,
    [nMinor]          BIGINT          NOT NULL,
    [nVersion]        AS              ([nMajor]*(4294967296.)+[nMinor]),
    [strDescription]  NVARCHAR (2048) NOT NULL,
    [strModifiedBy]   NVARCHAR (256)  NOT NULL,
    [dtModifiedTime]  DATETIME        NOT NULL,
    [nStatus]         TINYINT         NOT NULL,
    [imITML]          XML             NOT NULL,
    CONSTRAINT [itinerary_pk] PRIMARY KEY CLUSTERED ([strName] ASC, [nMajor] ASC, [nMinor] ASC)
);

